var express = require('express');
var router = express.Router();
var sqlite3 = require('sqlite3').verbose();
var path = require('path');
/* GET users listing. */
router.get('/', function (req, res, next) {
    var db = new sqlite3.Database(path.join(__dirname, "../db/Delphi.s3db"));
    try {
        sqlStr1 = "select expert_id,n21,n14,n7,fam from answer2_1";
        db.all(sqlStr1, function (err, rows) {
            table = {"code": 0,"msg": "","count": rows.length,"data":rows};
            res.status(200).json(table);
        });
    } catch (ex) {
        console.log(ex);
    }
});
module.exports = router;